X14DataValidation Properties

Properties

AllowBlank Gets or sets whether blank values are allowed.
Error Gets or sets the error message.
ErrorStyle Gets or sets the error style.
ErrorTitle Gets or sets the error dialog title.
Formula1 Gets or sets the first formula (x14:formula1/xm:f).
Formula2 Gets or sets the second formula (x14:formula2/xm:f).
ImeMode Gets or sets the IME mode.
Operator Gets or sets the comparison operator.
Prompt Gets or sets the prompt message.
PromptTitle Gets or sets the prompt title.
SequenceOfReferences Gets or sets the cell ranges the validation applies to (xm:sqref element).
ShowDropDown Gets or sets whether the in-cell dropdown is suppressed.
ShowErrorMessage Gets or sets whether the error message is shown.
ShowInputMessage Gets or sets whether the input message is shown.
Type Gets or sets the validation type.

See Also